SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 223573 LIMIT 1 [ RunTime:0.000544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 223573 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351411,659163,696461,756992,485290,698729,823326,172859,786812,824392,510982,629846,911204,658851,438146,21581,771253,182751,67340,565971,517648,432429,250976,332023,1002166,961994,470522,458985,680945,431901,203102,794500,906679,177877,1026772,243033,790295,881424,324025,214777,925939,530859,332684,933600,575369,677411,378031,557518,31150,510047,583167,380990,735614,222984,258747,381497,207661,1036397,811107,220771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 223573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 223573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001512s ]