SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419288 LIMIT 1 [ RunTime:0.001161s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419288 [ RunTime:0.002026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311308,469079,5783,439446,365499,1003116,226581,1030178,138157,618866,933172,429737,157278,191475,860329,521180,868775,194732,360404,834305,542340,816533,185340,568917,664753,375544,124846,193346,559122,612603,162269,296676,982238,86421,385146,540975,20959,623406,650926,875360,612484,860273,537038,289611,198596,781258,342517,315464,4240,707793,577111,529545,91077,393961,539362,551684,47504,84285,617664,457209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001765s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001346s ]