SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391118 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391118 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974557,121195,563399,497511,374196,595166,974974,892359,796971,984154,335251,772792,578739,312139,262791,389651,76832,881504,827154,147626,452815,384289,132296,530973,75201,719802,286704,704424,79966,760689,610610,472797,23945,832631,466614,781049,712254,722369,176378,791048,404630,682200,776857,661976,163793,795056,674729,601990,755950,275593,580589,945983,517012,228378,801205,899521,38062,523358,413422,397053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000815s ]