SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027462 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027462 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201398,1016492,592833,1016983,180208,647411,61949,432385,591239,795486,275384,681962,1005180,469488,191764,842072,281584,248271,867843,843331,20382,124400,331804,599720,98697,285668,610626,482917,685124,22584,95778,463466,674188,1006751,845580,95370,960767,24147,936031,787206,632883,119057,817335,54011,704809,487177,825903,564757,444247,485470,120246,91190,548801,227002,55138,245210,822295,463703,351242,818861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027462 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027462 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]